/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50719
Source Host           : localhost:3306
Source Database       : wangshui

Target Server Type    : MYSQL
Target Server Version : 50719
File Encoding         : 65001

Date: 2021-06-27 14:30:47
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for fyd_pgl_order
-- ----------------------------
DROP TABLE IF EXISTS `fyd_pgl_order`;
CREATE TABLE `fyd_pgl_order` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '订单标识符' ,
`username`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名' ,
`telephone`  varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话号码' ,
`total_price`  double NULL DEFAULT NULL COMMENT '总金额' ,
`delivery_address`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '送货地址' ,
`order_time`  timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '下单时间' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=19

;

-- ----------------------------
-- Records of fyd_pgl_order
-- ----------------------------
BEGIN;
INSERT INTO `fyd_pgl_order` VALUES ('2', '房老板', '11111111111', '68', '830宿舍3号床铺被窝', '2021-06-25 16:22:36'), ('3', '房大爷', '22222222222', '648', '830宿舍厕所', '2021-06-25 17:20:45'), ('4', '彭大爷', '2322344544', '34', '830宿舍4号床铺被窝', '2021-06-25 18:20:50'), ('5', '彭老板', '4565656566', '65', '广州星巴克女厕所', '2021-06-25 19:19:27');
COMMIT;

-- ----------------------------
-- Table structure for lqj_user
-- ----------------------------
DROP TABLE IF EXISTS `lqj_user`;
CREATE TABLE `lqj_user` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`username`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`password`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`telephone`  varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`register_time`  timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP ,
`popedom`  int(11) NULL DEFAULT NULL COMMENT '0：管理员；1：普通用户' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=23

;

-- ----------------------------
-- Records of lqj_user
-- ----------------------------
BEGIN;
INSERT INTO `lqj_user` VALUES ('1', '水娃', 'shuiwa', '13180313123', '2021-06-24 09:21:13', '0'), ('2', '刘大爷', 'junge', '13180313123', '2021-06-24 09:21:17', '1'), ('22', '刘权均', 'liuquanjun', '12345678901', '2021-06-24 09:22:22', '1');
COMMIT;

-- ----------------------------
-- Table structure for lyq_category
-- ----------------------------
DROP TABLE IF EXISTS `lyq_category`;
CREATE TABLE `lyq_category` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '商品类别标识符' ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品类别名称' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=5

;

-- ----------------------------
-- Records of lyq_category
-- ----------------------------
BEGIN;
INSERT INTO `lyq_category` VALUES ('1', '葫芦娃'), ('2', '大葫芦娃'), ('3', '水娃'), ('4', '水龙头');
COMMIT;

-- ----------------------------
-- Table structure for zyh_product
-- ----------------------------
DROP TABLE IF EXISTS `zyh_product`;
CREATE TABLE `zyh_product` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '商品标识符' ,
`name`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品名称' ,
`price`  double NULL DEFAULT NULL COMMENT '商品单价' ,
`add_time`  timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP ,
`category_id`  int(11) NULL DEFAULT NULL COMMENT '商品类别标识符' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=35

;

-- ----------------------------
-- Records of zyh_product
-- ----------------------------
BEGIN;
INSERT INTO `zyh_product` VALUES ('1', '沉香焙茶波波', '28', '2021-06-24 17:18:42', '1'), ('2', '豆豆波波茶', '27', '2021-06-24 17:18:42', '1'), ('3', '草莓蛋糕', '112', '2021-06-24 17:18:42', '3'), ('4', '多肉芒芒甘露', '27', '2021-06-24 17:18:42', '1'), ('5', '多肉葡萄', '29', '2021-06-24 17:18:42', '1'), ('6', '满杯橙橙', '25', '2021-06-24 17:18:42', '1'), ('7', '草莓魔法棒', '22', '2021-06-24 17:18:42', '2'), ('8', '草莓冰沙', '36', '2021-06-24 17:18:42', '4'), ('9', '草莓奶油可颂', '26', '2021-06-24 17:18:42', '2'), ('10', '草莓派', '24', '2021-06-24 17:18:42', '2'), ('11', '豆乳蛋糕 ', '98', '2021-06-24 17:18:42', '3'), ('12', '蓝莓蛋糕', '112', '2021-06-24 17:18:42', '3'), ('13', '芒果蛋糕', '108', '2021-06-24 17:18:42', '3'), ('14', '满杯红柚', '25', '2021-06-24 17:18:42', '1'), ('15', '鲷鱼烧冰淇淋', '28', '2021-06-24 17:18:42', '4'), ('16', '芒芒甘露椰椰冻', '29', '2021-06-24 17:18:42', '1'), ('17', '雪山莓莓桂花冻', '33', '2021-06-24 17:18:42', '1'), ('18', '超大芝士', '45', '2021-06-24 17:18:42', '2'), ('19', '焦糖布丁', '24', '2021-06-24 17:18:42', '2'), ('20', '蓝莓奶油泡芙', '25', '2021-06-24 17:18:42', '2'), ('21', '莓莓鲜奶吐司', '24', '2021-06-24 17:18:42', '2'), ('22', '香葱芝士蛋卷', '32', '2021-06-24 17:18:42', '2'), ('23', '抹茶水果多多蛋糕', '120', '2021-06-24 17:18:42', '3'), ('24', '南瓜芝士蛋糕', '112', '2021-06-24 17:18:42', '3'), ('25', '鲜奶油蛋糕', '85', '2021-06-24 17:18:42', '3'), ('26', '樱桃蛋糕', '108', '2021-06-24 17:18:42', '3'), ('27', '怪兽爆米花冰淇淋', '24', '2021-06-24 17:18:42', '4'), ('28', '芒芒雪糕杯', '24', '2021-06-24 17:18:42', '4'), ('29', '玫瑰甜筒', '32', '2021-06-24 17:18:42', '4'), ('30', '抹茶红豆冰淇淋', '24', '2021-06-24 17:18:42', '4'), ('31', '抹茶红豆冰沙', '32', '2021-06-24 17:18:42', '4'), ('32', '心冻角', '15', '2021-06-24 17:18:42', '4'), ('33', 'javaweb', '1', '2021-06-25 15:48:08', '1');
COMMIT;

-- ----------------------------
-- Auto increment value for fyd_pgl_order
-- ----------------------------
ALTER TABLE `fyd_pgl_order` AUTO_INCREMENT=19;

-- ----------------------------
-- Auto increment value for lqj_user
-- ----------------------------
ALTER TABLE `lqj_user` AUTO_INCREMENT=23;

-- ----------------------------
-- Auto increment value for lyq_category
-- ----------------------------
ALTER TABLE `lyq_category` AUTO_INCREMENT=5;

-- ----------------------------
-- Auto increment value for zyh_product
-- ----------------------------
ALTER TABLE `zyh_product` AUTO_INCREMENT=35;
